alter table shutdown_type add IS_DELETED bit default 0
go
update shutdown_type set IS_DELETED = 1 
go
insert into shutdown_type (SHUTDOWN_TYPE, DEPARTMENT1_ID)
values('设备缺陷', 4),('操作失误', 4),('公用工程影响', 4),('设计缺陷', 4),('制造缺陷', 4),('自然灾害', 4),('设备检维修因素', 4),('其他问题', 4)
go
alter table [shutdown] add ESCALATE_ZONGBU bit null
go
alter table [deleted_shutdown] add ESCALATE_ZONGBU bit null
go